﻿/********************************************************************************************************************
* Author:	Aristidis Mihail																						*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_category_softdelete_category" that		*
*			soft deletes a category																					*
********************************************************************************************************************/
CREATE PROCEDURE [dbo].[usp_category_softdelete_category]
	@CategoryID bigint
AS
	UPDATE Categories
	SET IsDeleted=1
	WHERE ID=@CategoryID

RETURN 0